



#delimit;


set mem 300000;
set mat 700;

set more off;



log using "C:\Old C Drive\F\INTIKAM2009\RESTAT\WEB_Final\Tables7_8.log",replace;


 
save "C:\Old C Drive\F\INTIKAM2009\RESTAT\WEB_Final\Table7_8data1.dta";

 
#delimit;


/* Table 5 (new table 7)*/

oprobit  intikam222 robbtly protect gun_coll male up50 edu avrburgtly_region    
 _20to24age _25to29age _30to34age _35to39age _40to44age _45to49age _50to54age _55to59age 
_60to64age _65to69age _70plusage single widow livtogether divorced  working lookforjob homekeeper
ret_disab   individualism rule_of_law_mean  elf85 english french german catholic muslim  democratic rgdpch1 kg 
pop1 _0to25per_new  sch25Mean  womenMean  war752000_noint dedu  europe c_europe mediter newasia2 africa lat_amer year1-year10 
[pweight=w005] ,robust cluster(count_code);


oprobit  intikam222  persthfttly  protect gun_coll male up50 edu avrburgtly_region    
 _20to24age _25to29age _30to34age _35to39age _40to44age _45to49age _50to54age _55to59age 
_60to64age _65to69age _70plusage single widow livtogether divorced  working lookforjob homekeeper
ret_disab   individualism rule_of_law_mean  elf85 english french german catholic muslim  democratic rgdpch1 kg 
pop1 _0to25per_new  sch25Mean  womenMean  war752000_noint dedu  europe c_europe mediter newasia2 africa lat_amer year1-year10 
[pweight=w005] ,robust cluster(count_code);


oprobit  intikam222  bicycthefttly  protect  gun_coll male up50 edu avrburgtly_region   
 _20to24age _25to29age _30to34age _35to39age _40to44age _45to49age _50to54age _55to59age 
_60to64age _65to69age _70plusage single widow livtogether divorced  working lookforjob homekeeper
ret_disab   individualism rule_of_law_mean  elf85 english french german catholic muslim  democratic rgdpch1 kg 
pop1 _0to25per_new  sch25Mean  womenMean  war752000_noint dedu  europe c_europe mediter newasia2 africa lat_amer year1-year10 
[pweight=w005] ,robust cluster(count_code);


oprobit  intikam222 assaulttly  protect gun_coll male up50 edu avrburgtly_region    
 _20to24age _25to29age _30to34age _35to39age _40to44age _45to49age _50to54age _55to59age 
_60to64age _65to69age _70plusage single widow livtogether divorced  working lookforjob homekeeper
ret_disab   individualism rule_of_law_mean  elf85 english french german catholic muslim  democratic rgdpch1 kg 
pop1 _0to25per_new  sch25Mean  womenMean  war752000_noint dedu  europe c_europe mediter newasia2 africa lat_amer year1-year10 
[pweight=w005] ,robust cluster(count_code);




/* (part of new new table 8) */

oprobit  intikam222  burgtly burgbef  robbtly protect  gun_coll male up50 edu avrburgtly_region     
 _20to24age _25to29age _30to34age _35to39age _40to44age _45to49age _50to54age _55to59age 
_60to64age _65to69age _70plusage single widow livtogether divorced  working lookforjob homekeeper
ret_disab   individualism rule_of_law_mean  elf85 english french german catholic muslim  democratic rgdpch1 kg 
pop1 _0to25per_new  sch25Mean  womenMean  war752000_noint dedu  europe c_europe mediter newasia2 africa lat_amer year1-year10 
[pweight=w005] ,robust cluster(count_code);


oprobit  intikam222  burgtly burgbef persthfttly   protect  gun_coll male up50 edu avrburgtly_region     
 _20to24age _25to29age _30to34age _35to39age _40to44age _45to49age _50to54age _55to59age 
_60to64age _65to69age _70plusage single widow livtogether divorced  working lookforjob homekeeper
ret_disab   individualism rule_of_law_mean  elf85 english french german catholic muslim  democratic rgdpch1 kg 
pop1 _0to25per_new  sch25Mean  womenMean  war752000_noint dedu  europe c_europe mediter newasia2 africa lat_amer year1-year10 
[pweight=w005] ,robust cluster(count_code);


oprobit  intikam222  burgtly burgbef bicycthefttly   protect gun_coll male up50 edu avrburgtly_region   
 _20to24age _25to29age _30to34age _35to39age _40to44age _45to49age _50to54age _55to59age 
_60to64age _65to69age _70plusage single widow livtogether divorced  working lookforjob homekeeper
ret_disab   individualism rule_of_law_mean  elf85 english french german catholic muslim  democratic rgdpch1 kg 
pop1 _0to25per_new  sch25Mean  womenMean  war752000_noint dedu  europe c_europe mediter newasia2 africa lat_amer year1-year10 
[pweight=w005] ,robust cluster(count_code);


oprobit  intikam222  burgtly burgbef  assaulttly  protect gun_coll male up50 edu avrburgtly_region     
 _20to24age _25to29age _30to34age _35to39age _40to44age _45to49age _50to54age _55to59age 
_60to64age _65to69age _70plusage single widow livtogether divorced  working lookforjob homekeeper
ret_disab   individualism rule_of_law_mean  elf85 english french german catholic muslim  democratic rgdpch1 kg 
pop1 _0to25per_new  sch25Mean  womenMean  war752000_noint dedu  europe c_europe mediter newasia2 africa lat_amer year1-year10 
[pweight=w005] ,robust cluster(count_code);




gen totalvic= robbtly + persthfttly + bicycthefttly + assaulttly;
gen TOTALvic=totalvic+burgtly;
gen total0=0;
replace total0=1 if totalvic==0;
gen total1=0;
replace total1=1 if totalvic==1;


gen TOTAL0=0;
replace TOTAL0=1 if TOTALvic==0;
gen TOTAL1=0;
replace TOTAL1=1 if TOTALvic==1;


/* table 7 (seond part of new table 8) */

oprobit  intikam222 burgtly burgbef robbtly persthfttly bicycthefttly assaulttly  protect gun_coll male up50 edu avrburgtly_region   
 _20to24age _25to29age _30to34age _35to39age _40to44age _45to49age _50to54age _55to59age 
_60to64age _65to69age _70plusage single widow livtogether divorced  working lookforjob homekeeper
ret_disab   individualism rule_of_law_mean  elf85 english french german catholic muslim  democratic rgdpch1 kg 
pop1 _0to25per_new  sch25Mean  womenMean  war752000_noint dedu  europe c_europe mediter newasia2 africa lat_amer year1-year10 
[pweight=w005] ,robust cluster(count_code);



oprobit  intikam222 burgtly burgbef total0  protect gun_coll male up50 edu avrburgtly_region   
 _20to24age _25to29age _30to34age _35to39age _40to44age _45to49age _50to54age _55to59age 
_60to64age _65to69age _70plusage single widow livtogether divorced  working lookforjob homekeeper
ret_disab   individualism rule_of_law_mean  elf85 english french german catholic muslim  democratic rgdpch1 kg 
pop1 _0to25per_new  sch25Mean  womenMean  war752000_noint dedu  europe c_europe mediter newasia2 africa lat_amer year1-year10 
[pweight=w005] ,robust cluster(count_code);


oprobit  intikam222 burgtly burgbef TOTAL0  protect gun_coll male up50 edu avrburgtly_region   
 _20to24age _25to29age _30to34age _35to39age _40to44age _45to49age _50to54age _55to59age 
_60to64age _65to69age _70plusage single widow livtogether divorced  working lookforjob homekeeper
ret_disab   individualism rule_of_law_mean  elf85 english french german catholic muslim  democratic rgdpch1 kg 
pop1 _0to25per_new  sch25Mean  womenMean  war752000_noint dedu  europe c_europe mediter newasia2 africa lat_amer year1-year10 
[pweight=w005],robust cluster(count_code);



oprobit  intikam222 burgtly burgbef   protect gun_coll male up50 edu avrburgtly_region   
 _20to24age _25to29age _30to34age _35to39age _40to44age _45to49age _50to54age _55to59age 
_60to64age _65to69age _70plusage single widow livtogether divorced  working lookforjob homekeeper
ret_disab   individualism rule_of_law_mean  elf85 english french german catholic muslim  democratic rgdpch1 kg 
pop1 _0to25per_new  sch25Mean  womenMean  war752000_noint dedu  europe c_europe mediter newasia2 africa lat_amer year1-year10 
[pweight=w005] if  TOTALvic>0 ,robust cluster(count_code);



/**********************************/

log close;
